from openpyxl import load_workbook
# 读取表格
def get_infomation(wenjian, sheet_name,num_id):

    wb = load_workbook(wenjian)
    sheet = wb[sheet_name]
    col1 = 0
    col2 = 2

    row = sheet[num_id]

    value1 = row[col1].value
    value2 = row[col2].value
    return value1, value2
